I have a spreadsheet with two columns of data imported from an Access file. The numbers in the Access file are in this format: 1234.5 and 12345.6; I want them to be displayed as: 12 34.5 and 123 45.6 in the Excel spreadsheet.
Using the custom format option in “format cells” is not working. I have tried the following custom format: 00 00.0 and 000 00.0 and although it works fine for data entered directly into the spreadsheet, it won’t work for the imported data.
Does anyone have any ideas as to how I can fix this? I do not want to reformat the Access data directly.
Thank you in advance,