Reformat using If statment based on cell format

**aiszeebee** · 03-15-2012, 04:16 AM

Hi folks,
The problem I’ve got essentially comes down to formatting. The data used in my spread sheet, which I have no control over. When the data is pasted across it has the ‘number stored as text’ error so I am reformatting the column. However this is taking awhile on my work PC for I was trying to add an if statement to check if the format is correct.

Please Login or Register  to view this content.

The problem is that my if statement runs no matter what. No doubt I’m missing something very obvious but I can’t find the correct format identifier. I have tried types like isnumeric but it still runs through the if (even when in the correct number format).
Also, on a side note, ideally I would like the range to adapt to populated cells, the problem is that in some cells the value is blank and that is correct. Ideally I’d like to link to column A which will always be populated but can’t find the correct thread. Any and all help is greatly appreciated.

**dangelor** · 03-15-2012, 05:46 PM

Does this do what you want?

Please Login or Register  to view this content.

Beware, the moderators will be on your case for not following the rules... Edit your post and use code tags.

**Mordred** · 03-15-2012, 05:56 PM

@dangelor, the moderators might get on your case as well for answering a question that does not follow forum rules.

**dangelor** · 03-15-2012, 06:13 PM

@Mordred... wouldn't be the first time.

**aiszeebee** · 03-16-2012, 04:00 AM

Many Thanks Guys.
Hopefully I am within the rules now. dangelor - I am just going to try the code and will let you know ASAP.
Cheers

**aiszeebee** · 03-16-2012, 04:30 AM

Thank you. I have tested with 2 different data set and works great and about 1000 times quicker then what I was trying to to. I guess its easy when you know how.
Thanks again