Help - random / through the workbook

[Image]

Hello,

Any idea why I now got /## throughout the document? Its like that for every tab.

Screenshot 2025-04-15 094804.jpg

[AliGW]

How would anyone know from a picture? Please attach the workbook.

Some formatting issue, possibly ...

[bsalv]

hello,
the contents is too large
https://www.google.com/search?q=cell...UZ40qiMxM,st:0

[AliGW]

That's not what the screenshot shows, which is why we still probably need to see the workbook. I am assuming it's the third row of the screenshot that is being referenced.

[Image]

Here is the workbook

Forum export.xlsx

[Image]

In column C for example, £1000/00 used to be £1000, I'm not sure where /00 is coming from.

[AliGW]

These are text values. They have been typed in that way, by the looks of it. Can you say more about when and how this happened? Do you have a copy of the workbook before all the currency cells 'changed'?

Have you done a find and replace to replace dots with slashes at some point?

Currency cells should be entered as number and currency formatting applied. You should NOT type the currency (£) into the cell as that means it's text.

[AliGW]

You can fix it with Find & Replace.

Find: /
Replace: .

Just make sure you are not targeting cells where there are slashes that you need to retain.

[AliGW]

Is this resolved now?

[Image]

Forum export March.xlsx

This is how it was late March.

[AliGW]

Did you do what I suggested in post #8?

[Image]

There are about 10 sheets, not all of them /00. Yes of course I can do this manually, but I thought I'd ask if its a function I don't know about.

[AliGW]

It's not a function and there's no way of knowing how it happened from what you've given us, I am afraid.

10 sheets is not a lot. You could probably fix it with Find & Replace in under half an hour, even if you have to be very selective with your cells.

I'd say fix it and move on, but keep a log of what you are doing so should it happen again, you have details of EXACTLY what you did that triggered it.

Sorry - at this point, there's nothing more we can do.

[Image]

ok thanks.

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.