Forum Discussion

Brass Contributor

Dec 01, 2022

Solved

Cell format

Hello all, I have the formula driven date values in column C. The cells of the column are formatted to show the different forms of dates which begin with “=” and ends with “,” signs. I want to past...

Formulas and Functions

HansVogelaar
Dec 02, 2022
A2Z CF

Change the line

For r = 1 To m

to

For r = 3 To 16

MVP

Dec 01, 2022

Perhaps

=--MID(C2,2,LEN(C2)-2)

or

=--SUBSTITUTE(SUBSTITUTE(C2,"=",""),",","")

A2Z CF
Brass Contributor
Dec 01, 2022
Thank you so much for your response, it still shows the date as mentioned in column D. I want the column C date format to be appear in column D as mentioned in next column "My desired value...". (I can get my desire value by converting the column D's cell as Date Format or as a text, but I want the value in plain Number or General format of the cell as mentioned in the next column "My desired value..." Like capturing the data in column C and pasting it to the column D without "=" and coma signs and without Date format of the cell). Thank you.
- HansVogelaar
  MVP
  Dec 01, 2022
  A2Z CF
  
  Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
  - A2Z CF
    Brass Contributor
    Dec 01, 2022
    Yes, here's the link. Thank you
    
    https://docs.google.com/spreadsheets/d/1eNnhy3oOqCgBOL8lL3TI_5ZFFHN20U-7/edit?usp=sharing&ouid=111964740657991279311&rtpof=true&sd=true

Resources