Forum Discussion
Solved
Representation of numbers in cell different to formula bar
Hi, I have an issue in a dataset where the values format in the cell is different from the value in the formula bar. Please see below: This is inconsistently present as an issue throughou...
- If some already have a point after the first number, then only Cell Format Custom
Enter: 0"."000
But if the existing point is not the first number, then probably only through VBA code.
Assume this is text. On a quick note, you could use the cell with the number divided by 1000 if the numbers are four digits and there is a period after the first number. Example: =A1/1000
or as Mr. Riny_van_Eekelen already mentioned,
Cell Format Custom
Enter: 0"."000
- Ah, I understand. Yes that's great, both of those are fixes. Thank you both. One issue still is that I need to fix quite a lot of these cells but some are correct already. Is there anyway I can separate out this correct data/ignore it when applying these fixes? Either the formatting or the formula...
- If some already have a point after the first number, then only Cell Format Custom
Enter: 0"."000
But if the existing point is not the first number, then probably only through VBA code.
